Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_SCHEDULER_CHAIN_STEPS

`ALL_SCHEDULER_CHAIN_STEPS` shows the defined steps of all chains visible to the current user (that is, those chains that the user has ALTER or EXECUTE privileges for).

Related Views

- `DBA_SCHEDULER_CHAIN_STEPS` shows the defined steps of all chains in the database.

- `USER_SCHEDULER_CHAIN_STEPS` shows the defined steps of all chains in the current user's schema. This view does not display the `OWNER` column.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Chain schema
`CHAIN_NAME` | `VARCHAR2(30)` | `NOT NULL` | Chain name
`STEP_NAME` | `VARCHAR2(30)` | `NOT NULL` | Chain step name
`PROGRAM_OWNER` | `VARCHAR2(98)` |  | Owner of the program that runs during this step
`PROGRAM_NAME` | `VARCHAR2(98)` |  | Name of the program that runs during this step
`EVENT_SCHEDULE_OWNER` | `VARCHAR2(98)` |  | Owner of the event schedule that this step waits for
`EVENT_SCHEDULE_NAME` | `VARCHAR2(98)` |  | Name of the event schedule that this step waits for
`EVENT_QUEUE_OWNER` | `VARCHAR2(30)` |  | Owner of source queue into which event will be raised
`EVENT_QUEUE_NAME` | `VARCHAR2(30)` |  | Name of source queue into which event will be raised
`EVENT_QUEUE_AGENT` | `VARCHAR2(30)` |  | Name of AQ agent used by the user on the event source queue (for a secure queue)
`EVENT_CONDITION` | `VARCHAR2(4000)` |  | Boolean expression used as the subscription rule for an event on the source queue
`SKIP` | `VARCHAR2(5)` |  | Whether or not this step should be skipped
`PAUSE` | `VARCHAR2(5)` |  | Whether or not this step should be paused after running
`RESTART_ON_RECOVERY` | `VARCHAR2(5)` |  | Whether or not this step should be restarted on database recovery
`STEP_TYPE` | `VARCHAR2(14)` |  | Type of this step
`TIMEOUT` | `INTERVAL DAY(3) TO SECOND(0)` |  | Timeout for waiting on an event schedule